package com.example.lab2.db;

import android.provider.BaseColumns;

public class TodolistContract {
    private TodolistContract(){}
    public static class TodolistEntry{
        public static final String TABLENAME="todolist";
        public static final String COL_NAME_ID= BaseColumns._ID;
        public static final String COL_NAME_DESCRIPTION="description";
        public static final String COL_NAME_DATE="date";
        public static final String COL_NAME_STATE="state";
    }
    public static final String SQL_CREATE_ENTRIES="CREATE TABLE "+TodolistEntry.TABLENAME+" ("+
            TodolistEntry.COL_NAME_ID+" INTEGER PRIMARY KEY, "+
            TodolistEntry.COL_NAME_DESCRIPTION+" TEXT,"+
            TodolistEntry.COL_NAME_DATE+" TEXT,"+
            TodolistEntry.COL_NAME_STATE+" INTEGER)";
    public static final String SDL_DELETE_ENTRIES="DROP TABLE IF EXISTS "+TodolistEntry.TABLENAME;
}
